-- ----------------------------
-- 该脚本用于删除自动生成的用户权限管理数据。在搭建初始环境的时候，不要执行该脚本。
-- 再次重新生成项目的时候，如果您在生成器中新增了用户权限相关的数据，而之前已经搭建好的数据库中，也存在了
-- 您自己手动插入的权限数据时，可以通过执行该脚本，将现有数据库表中，生成器生成的权限数据删除，删除之后，可以再执行新生成的数据库脚本数据。
-- 请仅在下面的数据库链接中执行该脚本。
-- 主数据源 [106.15.182.221:30066/evan]
-- ----------------------------

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- 全部菜单数据
-- ----------------------------
BEGIN;
DELETE FROM `mosys_menu` WHERE menu_id = '1781545342114729984';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545342135701504';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145569';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145570';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145571';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145572';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145573';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145574';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545342135701505';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145583';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145584';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145585';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145586';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145587';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145588';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545342135701506';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145597';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145598';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145599';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145600';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145601';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145602';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145603';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145604';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145605';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145606';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545342135701507';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145617';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145618';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145619';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145620';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145621';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145622';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145623';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145624';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145625';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545342135701508';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145635';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145636';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145637';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145638';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145639';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545342135701509';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145646';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145647';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145648';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145649';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145650';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545342135701510';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145658';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145659';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145660';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145661';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145662';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545342135701511';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145670';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145671';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145672';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145673';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145674';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145675';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145676';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145677';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545342135701512';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145688';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145689';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145690';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145691';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145692';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545342135701513';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145700';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545342135701514';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145704';
DELETE FROM `mosys_menu` WHERE menu_id = '1781545415150145705';

-- ----------------------------
-- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `mosys_menu` WHERE menu_id = '1634009076981567488';
DELETE FROM `mosys_menu` WHERE menu_id = '1392786950682841088';
DELETE FROM `mosys_menu` WHERE menu_id = '1392786549942259712';
DELETE FROM `mosys_menu` WHERE menu_id = '1392786476428693504';
COMMIT;

-- ----------------------------
-- 全部权限字数据
-- ----------------------------
BEGIN;
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145651';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145656';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145628';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145581';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145612';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145663';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145614';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145678';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145681';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145607';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145633';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145595';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145664';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145706';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145695';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145697';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145594';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145577';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145589';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145641';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145698';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145665';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145575';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145630';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145685';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145643';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145666';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145593';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145640';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145608';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145631';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145684';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145629';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145680';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145708';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145701';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145576';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145668';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145655';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145615';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145694';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145578';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145627';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145580';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145693';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145654';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145683';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145579';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145652';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145696';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145642';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145591';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145679';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145609';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145610';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145592';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145682';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145644';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145686';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145626';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145611';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145632';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145613';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145653';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145667';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145702';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145590';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1781545415150145707';

-- ----------------------------
-- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1639622363244924928';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1639622659975155712';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1400639252747784192';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1400639030462255104';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1400638885750378496';
DELETE FROM `mosys_perm_code` WHERE perm_code_id = '1400638673195634688';
COMMIT;

-- ----------------------------
-- 全部菜单和权限字关系数据
-- ----------------------------
BEGIN;
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145569' AND perm_code_id = '1781545415150145576';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145570' AND perm_code_id = '1781545415150145577';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145571' AND perm_code_id = '1781545415150145578';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145572' AND perm_code_id = '1781545415150145579';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145573' AND perm_code_id = '1781545415150145580';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145574' AND perm_code_id = '1781545415150145581';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145583' AND perm_code_id = '1781545415150145590';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145584' AND perm_code_id = '1781545415150145591';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145585' AND perm_code_id = '1781545415150145592';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145586' AND perm_code_id = '1781545415150145593';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145587' AND perm_code_id = '1781545415150145594';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145588' AND perm_code_id = '1781545415150145595';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145599' AND perm_code_id = '1781545415150145608';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145604' AND perm_code_id = '1781545415150145609';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145600' AND perm_code_id = '1781545415150145610';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145601' AND perm_code_id = '1781545415150145611';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145602' AND perm_code_id = '1781545415150145612';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145605' AND perm_code_id = '1781545415150145614';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145606' AND perm_code_id = '1781545415150145615';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145603' AND perm_code_id = '1781545415150145613';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145619' AND perm_code_id = '1781545415150145627';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145623' AND perm_code_id = '1781545415150145628';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145620' AND perm_code_id = '1781545415150145629';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145621' AND perm_code_id = '1781545415150145630';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145622' AND perm_code_id = '1781545415150145631';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145624' AND perm_code_id = '1781545415150145632';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145625' AND perm_code_id = '1781545415150145633';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145636' AND perm_code_id = '1781545415150145641';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145637' AND perm_code_id = '1781545415150145642';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145638' AND perm_code_id = '1781545415150145643';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145639' AND perm_code_id = '1781545415150145644';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145646' AND perm_code_id = '1781545415150145652';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145647' AND perm_code_id = '1781545415150145653';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145648' AND perm_code_id = '1781545415150145654';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145649' AND perm_code_id = '1781545415150145655';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145650' AND perm_code_id = '1781545415150145656';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145658' AND perm_code_id = '1781545415150145664';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145659' AND perm_code_id = '1781545415150145665';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145660' AND perm_code_id = '1781545415150145666';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145661' AND perm_code_id = '1781545415150145667';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145662' AND perm_code_id = '1781545415150145668';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145670' AND perm_code_id = '1781545415150145679';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145671' AND perm_code_id = '1781545415150145680';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145672' AND perm_code_id = '1781545415150145681';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145673' AND perm_code_id = '1781545415150145682';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145674' AND perm_code_id = '1781545415150145683';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145675' AND perm_code_id = '1781545415150145684';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145676' AND perm_code_id = '1781545415150145685';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145677' AND perm_code_id = '1781545415150145686';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545342135701512' AND perm_code_id = '1781545415150145694';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545342135701512' AND perm_code_id = '1781545415150145695';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545342135701512' AND perm_code_id = '1781545415150145696';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545342135701512' AND perm_code_id = '1781545415150145697';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545342135701512' AND perm_code_id = '1781545415150145698';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145688' AND perm_code_id = '1781545415150145694';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145689' AND perm_code_id = '1781545415150145695';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145690' AND perm_code_id = '1781545415150145696';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145691' AND perm_code_id = '1781545415150145697';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145692' AND perm_code_id = '1781545415150145698';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145700' AND perm_code_id = '1781545415150145702';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145704' AND perm_code_id = '1781545415150145707';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1781545415150145705' AND perm_code_id = '1781545415150145708';

-- ----------------------------
-- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1392786549942259712' AND perm_code_id = '1400638885750378496';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1392786950682841088' AND perm_code_id = '1400639252747784192';
DELETE FROM `mosys_menu_perm_code` WHERE menu_id = '1634009076981567488' AND perm_code_id = '1639622659975155712';
COMMIT;

-- ----------------------------
-- 全部权限资源模块数据
-- ----------------------------
BEGIN;
DELETE FROM `mosys_perm_module` WHERE module_id = '1781545342144090113';
DELETE FROM `mosys_perm_module` WHERE module_id = '1781545342144090112';
DELETE FROM `mosys_perm_module` WHERE module_id = '1781545342076981250';
DELETE FROM `mosys_perm_module` WHERE module_id = '1781545415150145551';
DELETE FROM `mosys_perm_module` WHERE module_id = '1781545342286696448';
DELETE FROM `mosys_perm_module` WHERE module_id = '1781545342357999616';
DELETE FROM `mosys_perm_module` WHERE module_id = '1781545415145951264';
DELETE FROM `mosys_perm_module` WHERE module_id = '1781545415145951276';
DELETE FROM `mosys_perm_module` WHERE module_id = '1781545415145951286';
DELETE FROM `mosys_perm_module` WHERE module_id = '1781545415145951292';
DELETE FROM `mosys_perm_module` WHERE module_id = '1781545415145951300';
DELETE FROM `mosys_perm_module` WHERE module_id = '1781545415150145536';
DELETE FROM `mosys_perm_module` WHERE module_id = '1781545415150145542';
DELETE FROM `mosys_perm_module` WHERE module_id = '1781545415150145552';
DELETE FROM `mosys_perm_module` WHERE module_id = '1781545415150145562';
DELETE FROM `mosys_perm_module` WHERE module_id = '1781545415150145564';

-- ----------------------------
-- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `mosys_perm_module` WHERE module_id = '1400626463740268544';
DELETE FROM `mosys_perm_module` WHERE module_id = '1400626237478539264';
DELETE FROM `mosys_perm_module` WHERE module_id = '1400626192725315584';
DELETE FROM `mosys_perm_module` WHERE module_id = '1400626018774945792';
DELETE FROM `mosys_perm_module` WHERE module_id = '1400625906245963776';
DELETE FROM `mosys_perm_module` WHERE module_id = '1400625585851469824';
DELETE FROM `mosys_perm_module` WHERE module_id = '1400625338886656000';
DELETE FROM `mosys_perm_module` WHERE module_id = '1400625224646397952';
DELETE FROM `mosys_perm_module` WHERE module_id = '1413404952566435840';
DELETE FROM `mosys_perm_module` WHERE module_id = '1400625106979393536';
COMMIT;

-- ----------------------------
-- 全部权限资源数据
-- ----------------------------
BEGIN;
DELETE FROM `mosys_perm` WHERE perm_id = '1781545342316056576';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545342316056591';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545342316056607';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545342316056609';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545342316056610';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545342341222400';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545342341222406';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545342341222412';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545342341222414';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545342349611008';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545342181838861';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545342181838860';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951245';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951246';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951247';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545342378971136';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545342383165446';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545342383165456';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545342383165458';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545342383165459';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545342395748352';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545342395748355';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545342395748358';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545342395748360';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951258';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951259';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951260';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951261';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951262';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951263';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951265';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951266';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951267';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951268';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951269';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951270';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951271';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951272';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951273';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951274';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951275';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951277';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951278';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951279';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951280';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951281';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951282';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951283';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951284';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951285';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951287';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951288';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951289';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951290';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951291';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951293';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951294';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951295';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951296';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951297';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951298';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951299';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951301';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951302';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951303';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951304';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951305';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951306';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415145951307';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415150145537';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415150145538';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415150145539';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415150145540';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415150145541';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415150145543';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415150145544';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415150145545';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415150145546';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415150145547';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415150145548';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415150145549';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415150145550';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415150145553';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415150145554';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415150145555';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415150145556';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415150145557';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415150145558';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415150145559';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415150145560';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415150145561';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415150145563';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415150145565';
DELETE FROM `mosys_perm` WHERE perm_id = '1781545415150145566';

-- ----------------------------
-- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `mosys_perm` WHERE perm_id = '1400637970863624193';
DELETE FROM `mosys_perm` WHERE perm_id = '1400637970863624192';
DELETE FROM `mosys_perm` WHERE perm_id = '1400637895328403456';
DELETE FROM `mosys_perm` WHERE perm_id = '1400637858414333952';
DELETE FROM `mosys_perm` WHERE perm_id = '1400637822737584128';
DELETE FROM `mosys_perm` WHERE perm_id = '1400637775962705920';
DELETE FROM `mosys_perm` WHERE perm_id = '1400637740705386496';
DELETE FROM `mosys_perm` WHERE perm_id = '1400636656679129088';
DELETE FROM `mosys_perm` WHERE perm_id = '1400636610403373056';
DELETE FROM `mosys_perm` WHERE perm_id = '1400636571165659136';
DELETE FROM `mosys_perm` WHERE perm_id = '1400636535371468800';
DELETE FROM `mosys_perm` WHERE perm_id = '1400636501900922880';
DELETE FROM `mosys_perm` WHERE perm_id = '1400636338838966272';
DELETE FROM `mosys_perm` WHERE perm_id = '1400636301480300544';
DELETE FROM `mosys_perm` WHERE perm_id = '1400636258107002880';
DELETE FROM `mosys_perm` WHERE perm_id = '1400636217728438272';
DELETE FROM `mosys_perm` WHERE perm_id = '1400636182936686592';
DELETE FROM `mosys_perm` WHERE perm_id = '1400636031752998912';
DELETE FROM `mosys_perm` WHERE perm_id = '1400635963469729792';
DELETE FROM `mosys_perm` WHERE perm_id = '1400635896461529088';
DELETE FROM `mosys_perm` WHERE perm_id = '1400635827347787776';
DELETE FROM `mosys_perm` WHERE perm_id = '1400635757332271104';
DELETE FROM `mosys_perm` WHERE perm_id = '1400635661106548736';
DELETE FROM `mosys_perm` WHERE perm_id = '1400635581532213248';
DELETE FROM `mosys_perm` WHERE perm_id = '1400635527698321408';
DELETE FROM `mosys_perm` WHERE perm_id = '1400635426808532992';
DELETE FROM `mosys_perm` WHERE perm_id = '1400635378506928128';
DELETE FROM `mosys_perm` WHERE perm_id = '1400635341274091520';
DELETE FROM `mosys_perm` WHERE perm_id = '1400635267726970880';
DELETE FROM `mosys_perm` WHERE perm_id = '1400635131969933312';
DELETE FROM `mosys_perm` WHERE perm_id = '1400634735549485056';
DELETE FROM `mosys_perm` WHERE perm_id = '1400634693472227328';
DELETE FROM `mosys_perm` WHERE perm_id = '1400634651944423424';
DELETE FROM `mosys_perm` WHERE perm_id = '1400634613151305728';
DELETE FROM `mosys_perm` WHERE perm_id = '1400634559896227840';
DELETE FROM `mosys_perm` WHERE perm_id = '1400634354593435648';
DELETE FROM `mosys_perm` WHERE perm_id = '1400634280308117504';
DELETE FROM `mosys_perm` WHERE perm_id = '1400634100498305024';
DELETE FROM `mosys_perm` WHERE perm_id = '1400634012745076736';
DELETE FROM `mosys_perm` WHERE perm_id = '1400633922085195776';
DELETE FROM `mosys_perm` WHERE perm_id = '1400633798403559424';
DELETE FROM `mosys_perm` WHERE perm_id = '1400633713376628736';
DELETE FROM `mosys_perm` WHERE perm_id = '1400633612201627648';
DELETE FROM `mosys_perm` WHERE perm_id = '1400633568027217920';
DELETE FROM `mosys_perm` WHERE perm_id = '1400633529678696448';
DELETE FROM `mosys_perm` WHERE perm_id = '1400633437093629952';
DELETE FROM `mosys_perm` WHERE perm_id = '1400633375525441536';
DELETE FROM `mosys_perm` WHERE perm_id = '1400632511620452352';
DELETE FROM `mosys_perm` WHERE perm_id = '1400632438635368448';
DELETE FROM `mosys_perm` WHERE perm_id = '1400632326538399744';
DELETE FROM `mosys_perm` WHERE perm_id = '1400632216169484288';
DELETE FROM `mosys_perm` WHERE perm_id = '1400632108514283520';
DELETE FROM `mosys_perm` WHERE perm_id = '1400627109692444672';
DELETE FROM `mosys_perm` WHERE perm_id = '1400626963806162944';
DELETE FROM `mosys_perm` WHERE perm_id = '1400626748101496832';
DELETE FROM `mosys_perm` WHERE perm_id = '1639621697092980736';
DELETE FROM `mosys_perm` WHERE perm_id = '1639621809328361472';
DELETE FROM `mosys_perm` WHERE perm_id = '1639621889154355200';
DELETE FROM `mosys_perm` WHERE perm_id = '1639621941444743168';
DELETE FROM `mosys_perm` WHERE perm_id = '1413405352866615296';
DELETE FROM `mosys_perm` WHERE perm_id = '1413405313788284928';
DELETE FROM `mosys_perm` WHERE perm_id = '1413405224021790720';
DELETE FROM `mosys_perm` WHERE perm_id = '1413405166471745536';
DELETE FROM `mosys_perm` WHERE perm_id = '1413405061278601216';
COMMIT;

-- ----------------------------
-- 全部权限字和权限资源关系数据
-- ----------------------------
BEGIN;
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145576' AND perm_id = '1781545342341222400';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145576' AND perm_id = '1781545342341222406';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145577' AND perm_id = '1781545342316056576';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145577' AND perm_id = '1781545342395748352';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145577' AND perm_id = '1781545415145951280';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145577' AND perm_id = '1781545415145951268';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145578' AND perm_id = '1781545342341222412';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145578' AND perm_id = '1781545342316056591';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145578' AND perm_id = '1781545342341222414';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145578' AND perm_id = '1781545342395748352';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145578' AND perm_id = '1781545415145951280';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145578' AND perm_id = '1781545415145951268';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145579' AND perm_id = '1781545342316056607';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145580' AND perm_id = '1781545342349611008';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145581' AND perm_id = '1781545415145951247';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145581' AND perm_id = '1781545415145951246';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145581' AND perm_id = '1781545415145951245';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145590' AND perm_id = '1781545342395748352';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145590' AND perm_id = '1781545342395748355';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145591' AND perm_id = '1781545342378971136';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145592' AND perm_id = '1781545342395748358';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145592' AND perm_id = '1781545342383165446';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145592' AND perm_id = '1781545342395748360';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145593' AND perm_id = '1781545342383165456';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145594' AND perm_id = '1781545415145951258';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145594' AND perm_id = '1781545415145951262';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145594' AND perm_id = '1781545415145951259';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145594' AND perm_id = '1781545415145951260';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145594' AND perm_id = '1781545415145951261';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145594' AND perm_id = '1781545415145951263';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145595' AND perm_id = '1781545415145951261';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145595' AND perm_id = '1781545415145951263';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145608' AND perm_id = '1781545415145951268';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145610' AND perm_id = '1781545415145951265';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145610' AND perm_id = '1781545415145951296';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145611' AND perm_id = '1781545415145951269';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145611' AND perm_id = '1781545415145951266';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145611' AND perm_id = '1781545415145951296';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145613' AND perm_id = '1781545415145951275';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145613' AND perm_id = '1781545415145951274';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145612' AND perm_id = '1781545415145951267';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145609' AND perm_id = '1781545415145951272';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145614' AND perm_id = '1781545415145951270';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145614' AND perm_id = '1781545415145951273';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145615' AND perm_id = '1781545415145951271';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145627' AND perm_id = '1781545415145951280';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145629' AND perm_id = '1781545415145951277';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145630' AND perm_id = '1781545415145951281';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145630' AND perm_id = '1781545415145951278';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145631' AND perm_id = '1781545415145951279';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145628' AND perm_id = '1781545415145951284';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145632' AND perm_id = '1781545415145951282';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145632' AND perm_id = '1781545415145951285';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145633' AND perm_id = '1781545415145951283';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145641' AND perm_id = '1781545415145951290';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145642' AND perm_id = '1781545415145951287';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145643' AND perm_id = '1781545415145951291';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145643' AND perm_id = '1781545415145951288';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145644' AND perm_id = '1781545415145951289';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145652' AND perm_id = '1781545415145951296';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145653' AND perm_id = '1781545415145951293';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145653' AND perm_id = '1781545415145951304';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145654' AND perm_id = '1781545415145951297';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145654' AND perm_id = '1781545415145951295';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145655' AND perm_id = '1781545415145951294';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145654' AND perm_id = '1781545415145951304';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145656' AND perm_id = '1781545415145951298';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145656' AND perm_id = '1781545415145951299';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145664' AND perm_id = '1781545415145951304';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145665' AND perm_id = '1781545415145951301';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145665' AND perm_id = '1781545415150145541';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145666' AND perm_id = '1781545415145951305';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145666' AND perm_id = '1781545415145951302';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145666' AND perm_id = '1781545415150145541';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145667' AND perm_id = '1781545415145951303';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145668' AND perm_id = '1781545415145951306';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145668' AND perm_id = '1781545415145951307';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145679' AND perm_id = '1781545415150145540';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145679' AND perm_id = '1781545415150145541';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145679' AND perm_id = '1781545415150145546';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145680' AND perm_id = '1781545415150145537';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145681' AND perm_id = '1781545415150145538';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145682' AND perm_id = '1781545415150145539';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145683' AND perm_id = '1781545415150145543';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145684' AND perm_id = '1781545415150145547';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145684' AND perm_id = '1781545415150145544';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145685' AND perm_id = '1781545415150145545';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145686' AND perm_id = '1781545415150145548';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145686' AND perm_id = '1781545415150145549';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145686' AND perm_id = '1781545415150145550';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145694' AND perm_id = '1781545415150145553';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145694' AND perm_id = '1781545415150145554';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145694' AND perm_id = '1781545415150145555';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145694' AND perm_id = '1781545415150145556';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145694' AND perm_id = '1781545415150145557';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145694' AND perm_id = '1781545415150145558';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145694' AND perm_id = '1781545415150145559';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145694' AND perm_id = '1781545415150145560';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145694' AND perm_id = '1781545415150145561';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145702' AND perm_id = '1781545415150145563';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145707' AND perm_id = '1781545415150145565';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1781545415150145708' AND perm_id = '1781545415150145566';

-- ----------------------------
-- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1639622659975155712' AND perm_id = '1400626748101496832';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1639622659975155712' AND perm_id = '1639621697092980736';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1639622659975155712' AND perm_id = '1639621809328361472';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1639622659975155712' AND perm_id = '1639621889154355200';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1639622659975155712' AND perm_id = '1639621941444743168';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400638885750378496' AND perm_id = '1400626748101496832';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400638885750378496' AND perm_id = '1400626963806162944';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400638885750378496' AND perm_id = '1400627109692444672';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400638885750378496' AND perm_id = '1400632108514283520';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400638885750378496' AND perm_id = '1400632216169484288';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400638885750378496' AND perm_id = '1400632326538399744';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400638885750378496' AND perm_id = '1400632438635368448';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400638885750378496' AND perm_id = '1400632511620452352';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400626748101496832';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400626963806162944';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400627109692444672';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400632108514283520';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400632216169484288';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400633375525441536';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400633437093629952';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400633529678696448';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400633568027217920';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400633612201627648';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400633713376628736';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400633798403559424';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400633922085195776';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400634012745076736';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400634100498305024';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400634280308117504';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400634354593435648';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400634559896227840';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400634613151305728';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400634651944423424';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400634693472227328';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400634735549485056';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400635131969933312';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400635267726970880';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400635341274091520';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400635378506928128';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400635426808532992';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400635527698321408';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400635581532213248';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400635661106548736';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400635757332271104';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400635827347787776';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400635896461529088';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400635963469729792';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400636031752998912';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400636182936686592';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400636217728438272';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400636258107002880';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400636301480300544';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400636338838966272';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400636501900922880';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400636535371468800';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400636571165659136';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400636610403373056';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400636656679129088';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400637740705386496';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400637775962705920';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400637822737584128';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400637858414333952';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400637895328403456';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400637970863624193';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1400637970863624192';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1413405352866615296';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1413405313788284928';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1413405224021790720';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1413405166471745536';
DELETE FROM `mosys_perm_code_perm` WHERE perm_code_id = '1400639252747784192' AND perm_id = '1413405061278601216';

DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/upms/login/getLoginInfo';
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/upms/sysRole/listDict';
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/upms/sysRole/listDictByIds';
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/upms/sysUser/list';
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/upms/sysMenu/listMenuDict';
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/upms/sysPost/listDict';
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/upms/sysPost/listDictByIds';
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/upms/sysPost/list';
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/upms/sysDept/listSysDeptPostWithRelation';
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/upms/sysDept/listAllChildDeptIdByParentIds';
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/upms/globalDict/listDict';
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/upms/globalDict/listDictByIds';
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/upms/globalDict/listAll';
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/upms/sysUser/listDict';
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/upms/sysUser/listDictByIds';
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/upms/sysDept/listDict';
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/upms/sysDept/listDictByIds';
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/upms/sysDept/listDictByParentId';
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/upms/login/doLogout';
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/upms/login/changePassword';
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/upms/login/changeHeadImage';
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/upms/login/downloadHeadImage';

-- ----------------------------
-- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/online/onlineDblink/testConnection';
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/online/onlineOperation/listDict';
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/online/onlineOperation/getColumnRuleCode';
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/online/onlineDict/listAllGlobalDict';

-- ----------------------------
-- 以下记录用于通用扩展，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/commonext/bizwidget/list';
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/commonext/bizwidget/view';
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/commonext/util/uploadImage';
DELETE FROM `mosys_perm_whitelist` WHERE perm_url = '/admin/commonext/util/downloadImage';

COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
